﻿

CREATE PROCEDURE [PomArchiveAddress]
(
	@pPomplingAddressID INT,
	@pCustomerID varchar(32)
)
AS
BEGIN
	SET NOCOUNT ON;	
		UPDATE [PomPomplingAddresses] set [Archived] = 1, ArchivedDate = GETDATE() WHERE [PomplingAddressID] = @pPomplingAddressID AND [PomplingCustomerID]  = @pCustomerID;
END